IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'spSys_UserSelectInfoByUserId')
	BEGIN
		DROP  Procedure  spSys_UserSelectInfoByUserId
	END
GO
-- =============================================
-- Author:		NAMTRANPHUONG
-- Create date: August 18, 2012
-- Description:	Select User infor
-- =============================================
CREATE PROCEDURE spSys_UserSelectInfoByUserId
	@UserId INT
AS
BEGIN
	
	SELECT [UserId]
      ,[Username]
      ,[Password]
      ,[DisplayName]
      ,[Email]
      ,[Mobile]
      ,[Address]
      ,[CreatedDate]
      ,[CreatedBy]
      ,[Status]
	FROM Sys_User
	WHERE UserId = @UserId
END
GO
